Overview: Delay
Use this operation to create a dataset with delayed data values for selected fields. These delays can be implemented on either the row number (index based) or as a number of seconds (time based). Multiple fields can be delayed, each by different values.
Index based delay:
-
The values of the selected fields will be shifted down the configured number of rows.
-
Your dataset will increase by the configured number of rows for the delay.
-
If you have 10 rows in your dataset for a specific field and you add a delay of 2 rows, your resulting dataset will have 12 rows, where the first 2 rows will have null values.
Time based delay:
-
Every timestamp will be delayed by your configured delay.
-
Your dataset will increase by the total configured number of timestamp delays, for each different field.
-
The values of the rows before the delayed value will be null.
Properties
Category: |
Transform |
Performance risk: |
High potential performance risk. The performance is influenced by the size of the text file being imported, which is determined by number of rows and/or the number of columns of the dataset. |
Knowledge required: |
Working knowledge of the software. |
Effect on datasets
How many datasets are required to perform this operation? |
One |
Does it create a new dataset? |
Yes |
Can you reconfigure this operation? |
Yes |
Can you apply this operation to a locked dataset? |
Yes |
Does it modify the current dataset in any way? |
No |
Requirements
-
A dataset with at least one field of any type.
Results
-
The resulting dataset will contain only the configured dataset fields with their values shifted to the new delayed position.
-
Rows preceding the delayed value will have null values.
-
Values to be delayed can either be interpolated or remain constant at the previous value.
Related topics: